﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of ProductShippingBox" >
	<Sql>
		SELECT
			id,
			weight as maxWeight_amount,weightUnit as maxWeight_unit,
			width as dimensions_width_amount,widthUnit as dimensions_width_unit,
			length as dimensions_length_amount,lengthUnit as dimensions_length_unit,
			depth as dimensions_depth_amount,depthUnit as dimensions_depth_unit
		FROM
			eComProductSpecificShippingBoxes
		WHERE
			productId = @productId;
	</Sql>

	<Param name="productId" type="UniqueIdentifier"/>
</AdoNetDataAccess>